Creating Custom Budget Calculations

You want to calculate the net planned budget for the month of January. The formula for calculation corresponds to the example in chapter Customized Budget Calculations: BNet = BPlan - (BPlan * F% + Fabs /(1 + Fabs))

Note

For the sake of clarity, the characters +-*/ and () are set in quotation marks in the instructions below. The quotation marks are not included in the entry in the Formula field!

  1. Starting from the sidebar navigation, click > Planner > Budget > Budget views > Manage views....

  2. In the Select column dropdown list, select the entry Formula.

  3. The Create New Column dialog box opens:

    Dialog for custom budget calculation formula

  4. Enter a name for the column (e.g. Net planned budget for January).

  5. In the Formula field, enter the first part of the formula, the planned budget:

    1. In the Content type dropdown list, select the entry Budget.

    2. In the Budget Type dropdown list, select the entry Planned.

    3. In the Period dropdown list, select the January entry.

    4. In the Year dropdown list, select the Displayed year entry.

    5. Make sure that the sum of children activities is not used for parent activities by unchecking the Sum of all children checkbox.

    6. Specify that the value in the working currency will be used.

    7. Click Add to formula.

  6. The <Budget - Planned - January - (Displayed year) - (Working currency)> entry is added in the Formula field.

  7. Enter the characters "- (" after the entry.

  8. Add the <Budget - Planned - January - (Displayed year) - (Working currency)> entry again. Alternatively, copy the <Budget - Planned - January - (Displayed year) - (Working currency)> entry and add it at the end of the line.

  9. Enter the character "*" at the end.

  10. Enter the percentage fee:

    1. In the Content type dropdown list, select the Fee entry.

    2. In the Fee dropdown list, select the Rate of percentage fee entry.

    3. In the Period dropdown list, select the January entry.

    4. Click Add to formula.

  11. The <Fee - Rate of percentage fee - January> entry is added in the Formula field.

  12. Enter the character "+" at the end.

  13. Enter the total of the absolute fees:

    1. In the Content type dropdown list, select the Fee entry.

    2. In the Fee dropdown list select the Sum of absolute value fees entry.

    3. In the Period dropdown list, select the January entry.

    4. Click Add to formula.

  14. The <Fee - Sum of absolute value fees - January> entry is added in the Formula field.

  15. Enter the characters "/(1+" at the end.

  16. Add the <Fee - Rate of percentage fee - January> entry again. Alternatively, copy the <Fee - Rate of percentage fee - January> entry and add it at the end of the line.

  17. Enter the characters "))" at the end.

  18. You have entered the formula. The Formula field now contains the following:

    <Budget - Planned - January - (Displayed year) - (Working currency)>-(<Budget - Planned - January - (Displayed year) - (Working currency)>*<Fee - Rate of percentage fee - January>+<Fee - Sum of absolute value fees - January>/(1+<Fee - Rate of percentage fee - January>))

  19. Choose Create Column.

  20. The dialog box closes. The Net planned budget for January column is added to the list of columns in the current budget view.

  21. Click Save.

The Edit Budget View dialog box closes. The column is displayed in the budget.